Tabela OncologyDeep

Definicja tabeli OncologyDeep

Name

OncologyDeep

Code

OncologyDeep

Comment

Tabela do zapisu diagnostyki poglebionej


Lista kolumn tabeli OncologyDeep

Name

Code

OncologyDeepID

OncologyDeepID

OncologicCardID

OncologicCardID

OtherPerfTestDescrID

OtherPerfTestDescrID

TumourICDID

TumourICDID

AdvanceLevelID

AdvanceLevelID

AdvanceStageID

AdvanceStageID

FurtherProceedingID

FurtherProceedingID

DiagnosisDoctorID

DiagnosisDoctorID

IssuingOrgUnitID

IssuingOrgUnitID

HistopatologyICDID

HistopatologyICDID

AdvanceLevelScaleID

AdvanceLevelScaleID

WaitingListItemStartDT

WaitingListItemStartDT

FirstAdviceDT

FirstAdviceDT

MalignantTumourCardNo

MalignantTumourCardNo

DiagnosisAdviceDT

DiagnosisAdviceDT

KZNZCancerNotificationDT

KZNZCancerNotificationDT

AdvanceLevelScaleValue

AdvanceLevelScaleValue

HistopatologyDescrID

HistopatologyDescrID


Kolumna OncologyDeepID tabeli OncologyDeep

Definicja kolumny OncologyDeepID tabeli OncologyDeep

Name

OncologyDeepID

Code

OncologyDeepID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Klucz glówny


Kolumna OncologicCardID tabeli OncologyDeep

Definicja kolumny OncologicCardID tabeli OncologyDeep

Name

OncologicCardID

Code

OncologicCardID

Data Type

NUMBER(10)

Mandatory

No

Comment

id karty


Kolumna OtherPerfTestDescrID tabeli OncologyDeep

Definicja kolumny OtherPerfTestDescrID tabeli OncologyDeep

Name

OtherPerfTestDescrID

Code

OtherPerfTestDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

opis innych wykonanych badan


Kolumna TumourICDID tabeli OncologyDeep

Definicja kolumny TumourICDID tabeli OncologyDeep

Name

TumourICDID

Code

TumourICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

ICDID nowotworu


Kolumna AdvanceLevelID tabeli OncologyDeep

Definicja kolumny AdvanceLevelID tabeli OncologyDeep

Name

AdvanceLevelID

Code

AdvanceLevelID

Data Type

NUMBER(10)

Mandatory

No

Comment

stopien zaawansowania


Kolumna AdvanceStageID tabeli OncologyDeep

Definicja kolumny AdvanceStageID tabeli OncologyDeep

Name

AdvanceStageID

Code

AdvanceStageID

Data Type

NUMBER(10)

Mandatory

No

Comment

stadium zaawansowania


Kolumna FurtherProceedingID tabeli OncologyDeep

Definicja kolumny FurtherProceedingID tabeli OncologyDeep

Name

FurtherProceedingID

Code

FurtherProceedingID

Data Type

NUMBER(10)

Mandatory

No

Comment

dalsze postepowanie (ze slownika)


Kolumna DiagnosisDoctorID tabeli OncologyDeep

Definicja kolumny DiagnosisDoctorID tabeli OncologyDeep

Name

DiagnosisDoctorID

Code

DiagnosisDoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

lekarz stawiajacy rozpoznanie


Kolumna IssuingOrgUnitID tabeli OncologyDeep

Definicja kolumny IssuingOrgUnitID tabeli OncologyDeep

Name

IssuingOrgUnitID

Code

IssuingOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

swiadczeniodawaca


Kolumna HistopatologyICDID tabeli OncologyDeep

Definicja kolumny HistopatologyICDID tabeli OncologyDeep

Name

HistopatologyICDID

Code

HistopatologyICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

rozpoznanie histopatologiczne


Kolumna AdvanceLevelScaleID tabeli OncologyDeep

Definicja kolumny AdvanceLevelScaleID tabeli OncologyDeep

Name

AdvanceLevelScaleID

Code

AdvanceLevelScaleID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna WaitingListItemStartDT tabeli OncologyDeep

Definicja kolumny WaitingListItemStartDT tabeli OncologyDeep

Name

WaitingListItemStartDT

Code

WaitingListItemStartDT

Data Type

DATE

Mandatory

No

Comment

data wpisu na kolejke oczekujacych


Kolumna FirstAdviceDT tabeli OncologyDeep

Definicja kolumny FirstAdviceDT tabeli OncologyDeep

Name

FirstAdviceDT

Code

FirstAdviceDT

Data Type

DATE

Mandatory

No

Comment

data pierwszej porady zwiazanej z diagnostyka poglebiona


Kolumna MalignantTumourCardNo tabeli OncologyDeep

Definicja kolumny MalignantTumourCardNo tabeli OncologyDeep

Name

MalignantTumourCardNo

Code

MalignantTumourCardNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna DiagnosisAdviceDT tabeli OncologyDeep

Definicja kolumny DiagnosisAdviceDT tabeli OncologyDeep

Name

DiagnosisAdviceDT

Code

DiagnosisAdviceDT

Data Type

DATE

Mandatory

No

Comment

data porady zakonczonej rozpoznaniem


Kolumna KZNZCancerNotificationDT tabeli OncologyDeep

Definicja kolumny KZNZCancerNotificationDT tabeli OncologyDeep

Name

KZNZCancerNotificationDT

Code

KZNZCancerNotificationDT

Data Type

DATE

Mandatory

No

Comment

data zgloszenia nowotworu do KZNZ


Kolumna AdvanceLevelScaleValue tabeli OncologyDeep

Definicja kolumny AdvanceLevelScaleValue tabeli OncologyDeep

Name

AdvanceLevelScaleValue

Code

AdvanceLevelScaleValue

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna HistopatologyDescrID tabeli OncologyDeep

Definicja kolumny HistopatologyDescrID tabeli OncologyDeep

Name

HistopatologyDescrID

Code

HistopatologyDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kolumna bedzie przechowyac dana opisowa rozpoznania histopatologicznego
(zastapi pole HistopatologyICDID)


Lista kluczy tabeli OncologyDeep

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OncologyDeep

Definicja klucza Identifier_1 tabeli OncologyDeep

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment